Create Staging Table in SSMS And Staging Package in SSIS

Download the SQL File attached to the  

Run Script that is attached to create your Staging tables in the Staging Database. Once ran, the tables will be made up of these columns.



*Open SSIS and Create a new project and name it - "BuildingPermitsInMiami" 



*Open SSIS Toolbox, Create a new package and name it - "BuildingPermits_Staging" Package.


Next , the following components will be dragged in the Control Flow Dashboard;











public void Main()

{

            // TODO: Add your code here


            string FILEPATH;

            string JSONFILENAME;


           FILEPATH = Dts.Variables["User::FILEPATH"].Value.ToString();

           JSONFILENAME = Path.GetFileName(FILEPATH);


            Dts.Variables["User::JSONFILENAME"].Value = JSONFILENAME;


            MessageBox.Show(JSONFILENAME);


            Dts.TaskResult = (int)ScriptResults.Success;


           

        }






The configuration of the data flow task will be carried on in the next step 

The final control flow pane should like this :



How to create basic SSIS package?